www.gusucode.com > XYCMS PHP留言板源码 v1.8PHP源码程序 > XYCMS PHP留言板源码 v1.8/xycmslyb_v1.8/xycmslyb_v1.8/system/manage_book.php
<?php
require 'include/session.php';
require 'include/globle.inc.php';
require XYCMS_IN . 'Libs/Class/page.class.php';
$x_m=$_GET['act'];
$x_keys=$_POST['keyword'];
if($x_m=='search' and $x_keys!=""){
$xy_sql="select * from xycms_book where b_title like '%$x_keys%' order by id desc,c_date desc";
}else{
$xy_sql="select * from xycms_book order by id desc,c_date desc";
}
$result=$db->query($xy_sql);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>信息管理</title>
<script type="text/javascript" src="Js/jquery.min.js"></script>
<link href="style/style.css" type="text/css" rel="stylesheet" />
<script type="text/javascript" src="Js/check.js"></script>
<script language="javascript">
function ask(msg) {
if( msg=='' ) {
msg='警告：删除后将不可恢复，可能造成意想不到后果？';
}
if (confirm(msg)) {
return true;
} else {
return false;
}
}
</script>
</head>
<body style="overflow-x:hidden;">
<div id="loader" >页面加载中...</div>
<div id="result" class="result none"></div>
<div class="mainbox">
<div id="nav" class="mainnav_title">
<ul>
<a href="manage_book.php">留言管理</a>| <a href="add_book.php">添加留言</a>
</ul>
</div>
<script>
//|str_replace=.'/index.php','',###
var onurl ='manage_book.php';
jQuery(document).ready(function(){
$('#nav ul a ').each(function(i){
if($('#nav ul a').length>1){
var thisurl= $(this).attr('href');
if(onurl.indexOf(thisurl) == 0 ) $(this).addClass('on').siblings().removeClass('on');
}else{
$('#nav ul').hide();
}
});
if($('#nav ul a ').hasClass('on')==false){
$('#nav ul a ').eq(0).addClass('on');
}
});
</script>
<table class="search_table" width="100%">
<tr>
<td class="search"><form action="?act=search" method="post">
<input id="keyword" type="text" size="14" class="input-text" name="keyword" />
<input type="submit" value="查询" class="button" />
<input type="reset" value="重置" class="button" />
</form></td>
</tr>
</table>
<form name="addform" id="addform" action="?del=checkbox" method="post">
<?php
$total=$db->num_rows($result);
$page=new page_link($total,30);
$xy_sql.=" limit $page->firstcount,$page->displaypg";
$result=$db->query($xy_sql);
?>
<div class="table-list">
<table width="100%" cellspacing="0">
<thead>
<tr>
<th width="30"><input type="checkbox" name="allbox" id="check_box" onclick="CheckAll()"></th>
<th width="40">ID</th>
<th>标题</th>
<th width="140">状态</th>
<th width="120">查看回复/<font color="#FF0000">[回复数]</font></th>
<th width="220">管理操作</th>
</tr>
</thead>
<tbody>
<?php
while($row=mysql_fetch_array($result)){
$f_date=date('Ymd',$row['c_date']);
?>
<tr>
<td width="30" align="center"><input class="inputcheckbox " name="id[]" id="id[]" value="<?php echo $row['id'];?>" type="checkbox" ></td>
<td align="center"><?php echo $row['id'];?></td>
<td><?php echo getcategoryname($row['type_id']);?> <?php echo htmlspecialchars($row['b_title']);?> </td>
<td align="center"><?php if($row['is_view']==1){?><font color="green">已审核</font><?php }else{?><font color="red">未审核</font><?php }?></td>
<td align="center"><a href="manage_reply.php?bid=<?php echo $row['id'];?>" class="a_btn">查看回复</a> / <font color="#FF0000"><?php getnums($row['id']);?></font></td>
<td align="center"><a href="hf_book.php?id=<?php echo $row['id'];?>" class="a_btn">新回复</a> | <a href="edit_book.php?id=<?php echo $row['id'];?>" class="a_btn">查看/编辑</a> | <a href="javascript:if(ask('警告：删除后将不可恢复，可能造成意想不到后果？')) location.href='del_book.php?id=<?php echo $row['id'];?>';" onClick="delcfm();" class="a_btn">删除</a></td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<div class="btn">
<select name="lx" id="lx" class="input_select">
<option selected="selected" value="">操作类型</option>
<option value="1">通过审核</option>
<option value="2">取消审核</option>
<option value="3">批量删除</option>
</select>
<input type="submit" class="button" name="dosubmit" value="提交操作" />
</div>
</form>
</div>
<div id="pages" class="page">
<?php echo $page->show_link();?>
</div>
</body>
</html>
<?php
function getcategoryname($catid){
global $db;
$sql="select title from xycms_book_class where id=$catid";
$result =$db->query($sql);
if($result && mysql_affected_rows()){
$row =$db->get_one($sql,MYSQL_ASSOC);
echo "[<font color='green'>".$row['title']."</font>]";
}else{
return '';
}
}
function getnums($catid){
global $db;
$sql="select id from xycms_book_reply where b_id=$catid";
$result =$db->query($sql);
if($result && mysql_affected_rows()){
echo "[<font color='#FF0000'>".$db->num_rows($result)."</font>]";
}else{
echo "[<font color='#FF0000'>0</font>]";
}
}
if($_GET['del']=='checkbox'){
$ids=$_POST['id'];
if(empty($ids)){
echo"<script>alert('必须选择一个ID,才可以操作!');history.back(-1);</script>";
exit;
}else{
$cz_lx=$_POST['lx'];
if($cz_lx==''){
echo"<script>alert('必须选择一个有效操作!');history.back(-1);</script>";
exit;
}
$id=implode(",",$ids);
switch($cz_lx){
case 1:
$sql="UPDATE xycms_book set is_view=1 where id in ($id)";
break;
case 2:
$sql="UPDATE xycms_book set is_view=0 where id in ($id)";
break;
case 3:
$sql="DELETE FROM xycms_book where id in ($id)";
break;
}
$db->query($sql);
echo "<script>alert('恭喜你，操作成功！');window.location.href='manage_book.php';</script>";
}
}
$db->close();
?>